www.gusucode.com > 落叶冰点万能企业网站内容管理系统 V9.1 > 落叶冰点万能企业网站内容管理系统 V9.1\code\admin\adminLabel\D_ajax_update_label_to_mdb_from_files_by_step.asp

    <%


'**************************************************************
' 新动软网站管理系统
' 官方网站: http://www.aspcpu.com
' 系统作者: 阮丁远(网名：天下程序)
' Copyright 新动软网站管理系统 版权所有
'**************************************************************


%>









<%

dir_set="../../"


%>


<!--#include file=../../inc/conn.asp-->






<!--#include file=../inc/checkadmin2.asp-->

<!--#include file=../../inc/functionFiless.asp-->



<!--#include file=../../inc/ND_class_function.asp-->


<%

set filea=new Cls_FSO
set fileb=new DosAsp 



'11,不用再改,11可能正好负载，不然服务器过载了
per=11



ended=0


if request("pos")="" then






conn.execute("delete from ND_label_cache")




Const JET_3X = 4

Function CompactDB(dbPath, boolIs97)

'-------------------new code1--------------------
'重要
on error resume next
'-------------------new code1--------------------


Dim fso, Engine, strDBPath
strDBPath = left(dbPath,instrrev(DBPath,""))


Set fso = CreateObject(fssoo_nd_var_str_x_customx)



'-------------------new code2--------------------
if fso.FileExists(strDBPath & "temp.mdb") then
fso.DeleteFile(strDBPath & "temp.mdb")
end if
'-------------------new code2--------------------




If fso.FileExists(dbPath) Then
Set Engine = CreateObject("JRO.JetEngine")

If boolIs97 = "True" Then
Engine.CompactDatabase "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & dbpath, _
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strDBPath & "temp.mdb;" _
& "Jet OLEDB:Engine Type=" & JET_3X
Else
Engine.CompactDatabase "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & dbpath, _
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strDBPath & "temp.mdb"
End If
fso.CopyFile strDBPath & "temp.mdb",dbpath
fso.DeleteFile(strDBPath & "temp.mdb")
Set fso = nothing
Set Engine = nothing
CompactDB = "你的数据库 " & dbpath & " 已经压缩完毕" & vbCrLf
Else
CompactDB = "The database name or path has not been found. Try Again" & vbCrLf
End If

End Function



    If IsObject(conn) Then
        conn.Close
        Set conn = Nothing
    End If

call CompactDB(Server.MapPath(dir_set&main_data_mdb), "-1")



call OpenConn()





sql=""
else

sql=" where id>"&request("pos")

end if


%>



<%

set rs1=server.CreateObject("adodb.recordset")
       
rs1.open "select * from ND_label_list_cache "&sql&" order by id asc",conn,1,1



for iggfg=1 to per
if rs1.eof then

ended=1
exit for

end if

now_pos1=rs1("id")


path1=rs1("label_full_path_filename")
if rs1("is_sys")="0" then

ppath="Label/custom_Label/"

else

ppath="Label/sys_Label/"
end if


cont11=loadfile("../../"&ppath&path1)

call get_info_array_from_label_file_content(cont11)




'response.write "type:"&nd1_label_type&"<br>"
'response.write "name:"&nd1_l_name&"<br>"
'response.write "sql:"&nd1_label_sql&"<br>"
'response.write "params:"&nd1_label_params&"<br>"
'response.write "fenye:"&nd1_label_fenye_num&"<br>"
'response.write "beizhu:"&nd1_label_beizhu&"<br>"
'response.write "other_params:"&nd1_other_params&"<br>"
'response.write "is_sys:"&nd1_is_sys_label&"<br>"
'response.write  nd1_label_code


set rs4=server.CreateObject("adodb.recordset")
       
rs4.open "select * from ND_label_cache",conn,1,3

rs4.addnew



rs4("label_code")=nd1_label_code
rs4("label_name")=nd1_l_name
rs4("label_full_path_name")=trim(ppath&path1)
rs4("label_params")=nd1_label_params
rs4("label_type")=nd1_label_type
rs4("label_sql")=nd1_label_sql
rs4("label_fenye_num")=nd1_label_fenye_num
rs4("label_beizhu")=nd1_label_beizhu
rs4("is_sys_label")=rs1("is_sys")
rs4("label_other_params")=nd1_other_params


rs4.update

rs4.close

set rs4=nothing

rs1.movenext



next

rs1.close
set rs1=nothing





response.ContentType="text/xml"

response.write "<?xml   version=""1.0""   encoding=""gb2312""?>"

response.write "<aaaa>"
response.write "<affff><![CDATA["&ended
response.write "]]></affff><affff2><![CDATA["&now_pos1&"]]></affff2><affff5><![CDATA["&left((path1),35)&"]]></affff5></aaaa>"




















%>